﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using StateGrid.MDBservice;

namespace StateGrid.KJCG
{
    /// <summary>
    ///KJCG_PM 的摘要说明
    /// </summary>
    public class KJCG_PM : PM
    {
        /// <summary>
        ///分类编码
        /// </summary>
        public String flbm
        {
            get;
            set;
        }

        /// <summary>
        /// 专业代码
        /// </summary>
        public String zydm
        {
            get;
            set;
        }

        /// <summary>
        /// 成果代码
        /// </summary>
        public String cgdm
        {
            get;
            set;
        }

        /// <summary>
        /// 上报编码
        /// </summary>
        public String sbbm
        {
            get;
            set;
        }

        /// <summary>
        /// 中文名称
        /// </summary>
        public String zwmc
        {
            get;
            set;
        }

        /// <summary>
        /// 成果类别
        /// </summary>
        public String cglb
        {
            get;
            set;
        }

        /// <summary>
        /// 起始日期
        /// </summary>
        public DateTime? qsrq
        {
            get;
            set;
        }

        /// <summary>
        /// 终止日期
        /// </summary>
        public DateTime? zzrq
        {
            get;
            set;
        }

        /// <summary>
        /// 学科代码
        /// </summary>
        public String xkdm
        {
            get;
            set;
        }

        /// <summary>
        /// 国图分类
        /// </summary>
        public String gtfl
        {
            get;
            set;
        }

        /// <summary>
        /// 中文主题词
        /// </summary>
        public String zwztc
        {
            get;
            set;
        }

        /// <summary>
        /// 中文文摘
        /// </summary>
        public String zwwz
        {
            get;
            set;
        }

        /// <summary>
        /// 课题来源
        /// </summary>
        public String ktly
        {
            get;
            set;
        }

        /// <summary>
        /// 评价方式
        /// </summary>
        public String pjfs
        {
            get;
            set;
        }

        /// <summary>
        /// 评价单位
        /// </summary>
        public String pjdw
        {
            get;
            set;
        }

        /// <summary>
        /// 评价日期
        /// </summary>
        public DateTime? pjrq
        {
            get;
            set;
        }

        /// <summary>
        /// 评价意见
        /// </summary>
        public String pjyj
        {
            get;
            set;
        }

        /// <summary>
        /// 奖项名称
        /// </summary>
        public String jxmc
        {
            get;
            set;
        }
        /// <summary>
        /// 奖励单位
        /// </summary>
        public String jldw
        {
            get;
            set;
        }
        /// <summary>
        /// 奖励年度
        /// </summary>
        public String jlnd
        {
            get;
            set;
        }
        /// <summary>
        /// 授奖等级
        /// </summary>
        public String sjdj
        {
            get;
            set;
        }
        /// <summary>
        /// 产权形式
        /// </summary>
        public String cqxs
        {
            get;
            set;
        }

        /// <summary>
        /// 产权名称
        /// </summary>
        public String cqmc
        {
            get;
            set;
        }

        /// <summary>
        /// 产权标示
        /// </summary>
        public String cqbs
        {
            get;
            set;
        }
        /// <summary>
        /// 第一单位
        /// </summary>
        public String dydw
        {
            get;
            set;
        }
        /// <summary>
        /// 单位属性
        /// </summary>
        public String dwsx
        {
            get;
            set;
        }
        /// <summary>
        /// 隶属关系
        /// </summary>
        public String lsgx
        {
            get;
            set;
        }
        /// <summary>
        /// 通讯地址
        /// </summary>
        public String txdz
        {
            get;
            set;
        }
        /// <summary>
        /// 邮政编码
        /// </summary>
        public String yzbm
        {
            get;
            set;
        }
        /// <summary>
        /// 联系电话
        /// </summary>
        public String lxdh
        {
            get;
            set;
        }
        /// <summary>
        /// 传真电话
        /// </summary>
        public String czdh
        {
            get;
            set;
        }
        /// <summary>
        /// 联系人
        /// </summary>
        public String lxr
        {
            get;
            set;
        }
        /// <summary>
        /// 电子信箱
        /// </summary>
        public String dzxx
        {
            get;
            set;
        }
        /// <summary>
        /// 其他单位
        /// </summary>
        public String qtdw
        {
            get;
            set;
        }
        /// <summary>
        /// 第一完成人
        /// </summary>
        public String dywcr
        {
            get;
            set;
        }
        /// <summary>
        /// 性别
        /// </summary>
        public String xb
        {
            get;
            set;
        }
        /// <summary>
        /// 职务职称
        /// </summary>
        public String zwzc
        {
            get;
            set;
        }
        /// <summary>
        /// 所在单位
        /// </summary>
        public String szdw
        {
            get;
            set;
        }
        /// <summary>
        /// 电话
        /// </summary>
        public String dh
        {
            get;
            set;
        }
        /// <summary>
        /// 其他完成人
        /// </summary>
        public String qtwcr
        {
            get;
            set;
        }
        /// <summary>
        /// 推荐单位意见
        /// </summary>
        public String tjdwyj
        {
            get;
            set;
        }
        /// <summary>
        /// 更新日期
        /// </summary>
        public DateTime gxrq
        {
            get;
            set;
        }
        /// <summary>
        /// 共享
        /// </summary>
        public Boolean gx
        {
            get;
            set;
        }

        /// <summary>
        /// 登录人
        /// </summary>
        public String dlr
        {
            get;
            set;
        }

        public KJCG_PM()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }
        public override string ToString()
        {
            String ret;
            ret = "[分类编码]" + this.flbm + "[成果代码]" + this.cgdm + " [中文名称]" + this.zwmc;
            return ret;
        }

        public override string AllContent()
        {
            String ret = "('" + flbm + "','" + zydm + "','" + cgdm + "','" + sbbm + "','" + zwmc + "','" + cglb + "','" + qsrq + "','" + zzrq + "','" + xkdm + "','" + gtfl + "','" + zwztc + "','" + zwwz + "','" + ktly + "','" + pjfs + "','" + pjdw + "','" + pjrq + "','" + pjyj + "','" + jxmc + "','" + jldw + "','" + jlnd + "','" + sjdj + "','" + cqxs + "','" + cqmc + "','" + cqbs + "','" + dydw + "','" + dwsx + "','" + lsgx + "','" + txdz + "','" + yzbm + "','" + lxdh + "','" + czdh + "','" + lxr + "','" + dzxx + "','" + qtdw + "','" + dywcr + "','" + xb + "','" + zwzc + "','" + szdw + "','" + dh + "','" + qtwcr + "','" + tjdwyj + "','" + gxrq + "','" + gx + "','" + dlr + "')";
            return ret;
        }

        public override void fillEmptyStringAsNull()
        {
            String temp = "NULL";
            if (String.Empty.Equals(this.flbm)) flbm = temp;
            if (String.Empty.Equals(this.zydm)) zydm = temp;
            if (String.Empty.Equals(this.cgdm)) cgdm = temp;
            if (String.Empty.Equals(this.sbbm)) sbbm = temp;
            if (String.Empty.Equals(this.zwmc)) zwmc = temp;
            if (String.Empty.Equals(this.cglb)) cglb = temp;
            if (String.Empty.Equals(this.xkdm)) xkdm = temp;
            if (String.Empty.Equals(this.gtfl)) gtfl = temp;
            if (String.Empty.Equals(this.zwztc)) zwztc = temp;
            if (String.Empty.Equals(this.zwwz)) zwwz = temp;
            if (String.Empty.Equals(this.ktly)) ktly = temp;
            if (String.Empty.Equals(this.pjfs)) pjfs = temp;
            if (String.Empty.Equals(this.pjdw)) pjdw = temp;
            if (String.Empty.Equals(this.pjyj)) pjyj = temp;
            if (String.Empty.Equals(this.jxmc)) jxmc = temp;
            if (String.Empty.Equals(this.jldw)) jldw = temp;
            if (String.Empty.Equals(this.jlnd)) jlnd = temp;
            if (String.Empty.Equals(this.sjdj)) sjdj = temp;
            if (String.Empty.Equals(this.cqxs)) cqxs = temp;
            if (String.Empty.Equals(this.cqmc)) cqmc = temp;
            if (String.Empty.Equals(this.cqbs)) cqbs = temp;
            if (String.Empty.Equals(this.dydw)) dydw = temp;
            if (String.Empty.Equals(this.dwsx)) dwsx = temp;
            if (String.Empty.Equals(this.lsgx)) lsgx = temp;
            if (String.Empty.Equals(this.txdz)) txdz = temp;
            if (String.Empty.Equals(this.yzbm)) yzbm = temp;
            if (String.Empty.Equals(this.lxdh)) lxdh = temp;
            if (String.Empty.Equals(this.czdh)) czdh = temp;
            if (String.Empty.Equals(this.lxr)) lxr = temp;
            if (String.Empty.Equals(this.dzxx)) dzxx = temp;
            if (String.Empty.Equals(this.qtdw)) qtdw = temp;
            if (String.Empty.Equals(this.dywcr)) dywcr = temp;
            if (String.Empty.Equals(this.xb)) xb = temp;
            if (String.Empty.Equals(this.zwzc)) zwzc = temp;
            if (String.Empty.Equals(this.szdw)) szdw = temp;
            if (String.Empty.Equals(this.dh)) dh = temp;
            if (String.Empty.Equals(this.qtwcr)) qtwcr = temp;
            if (String.Empty.Equals(this.tjdwyj)) dlr = temp;
        }

        public override void eraseNullInEmptyString()
        {
            String temp = "NULL";
            if (temp.Equals(this.flbm)) flbm = String.Empty;
            if (temp.Equals(this.zydm)) zydm = String.Empty;
            if (temp.Equals(this.cgdm)) cgdm = String.Empty;
            if (temp.Equals(this.sbbm)) sbbm = String.Empty;
            if (temp.Equals(this.zwmc)) zwmc = String.Empty;
            if (temp.Equals(this.cglb)) cglb = String.Empty;
            if (temp.Equals(this.xkdm)) xkdm = String.Empty;
            if (temp.Equals(this.gtfl)) gtfl = String.Empty;
            if (temp.Equals(this.zwztc)) zwztc = String.Empty;
            if (temp.Equals(this.zwwz)) zwwz = String.Empty;
            if (temp.Equals(this.ktly)) ktly = String.Empty;
            if (temp.Equals(this.pjfs)) pjfs = String.Empty;
            if (temp.Equals(this.pjdw)) pjdw = String.Empty;
            if (temp.Equals(this.pjyj)) pjyj = String.Empty;
            if (temp.Equals(this.jxmc)) jxmc = String.Empty;
            if (temp.Equals(this.jldw)) jldw = String.Empty;
            if (temp.Equals(this.jlnd)) jlnd = String.Empty;
            if (temp.Equals(this.sjdj)) sjdj = String.Empty;
            if (temp.Equals(this.cqxs)) cqxs = String.Empty;
            if (temp.Equals(this.cqmc)) cqmc = String.Empty;
            if (temp.Equals(this.cqbs)) cqbs = String.Empty;
            if (temp.Equals(this.dydw)) dydw = String.Empty;
            if (temp.Equals(this.dwsx)) dwsx = String.Empty;
            if (temp.Equals(this.lsgx)) lsgx = String.Empty;
            if (temp.Equals(this.txdz)) txdz = String.Empty;
            if (temp.Equals(this.yzbm)) yzbm = String.Empty;
            if (temp.Equals(this.lxdh)) lxdh = String.Empty;
            if (temp.Equals(this.czdh)) czdh = String.Empty;
            if (temp.Equals(this.lxr)) lxr = String.Empty;
            if (temp.Equals(this.dzxx)) dzxx = String.Empty;
            if (temp.Equals(this.qtdw)) qtdw = String.Empty;
            if (temp.Equals(this.dywcr)) dywcr = String.Empty;
            if (temp.Equals(this.xb)) xb = String.Empty;
            if (temp.Equals(this.zwzc)) zwzc = String.Empty;
            if (temp.Equals(this.szdw)) szdw = String.Empty;
            if (temp.Equals(this.dh)) dh = String.Empty;
            if (temp.Equals(this.qtwcr)) qtwcr = String.Empty;
            if (temp.Equals(this.tjdwyj)) tjdwyj = String.Empty;
            if (temp.Equals(this.dlr)) dlr = String.Empty;
        }
    }
}